Oracle 23AI 23.3.0.0 DB for OEL9.4
1 背景知识
本章主要介绍如何在 Oracle Linux 9.4 上安装 Oracle 23AI 数据库。
2 操作系统准备
2.1 preinstall 安装
安装Oracle 提供的操作系统批处理脚本。
#root>
dnf -y install oracle-database-preinstall-23ai
2.2 关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
2.3 下载数据库并上传
点击下载地址，选择需要被安装的数据库。
#root>
mkdir -p /app/setup
ls -l /app/setup/oracle-database-free-23ai-*.el9.x86_64.rpm
Warning
到此环境准备完成，请打快照 DB_INSTALL_ENV。
3 数据库安装
3.1 数据库安装
#root>
cd /app/setup
dnf -y install oracle-database-free-23ai-*.el9.x86_64.rpm
3.2 数据库配置
/etc/init.d/oracle-free-23ai configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
********
Enter SYSTEM user password:
*******
Enter PDBADMIN User Password:
*****
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: node/FREEPDB1
Multitenant container database: node
Note
输入密码即可。
3.3 配置、数据库文件和日志位置
| 文件名和位置 | 目的 |
|---|---|
/opt/oracle |
Oracle base。这是 Oracle Database Free 目录树的根目录。 |
/opt/oracle/product/23ai/dbhomeFree |
Oracle 主目录。此主页是安装 Oracle Database Free 的位置。它包含 Oracle Database Free 可执行文件和网络文件的目录。 |
/opt/oracle/oradata/FREE |
数据库文件。 |
/opt/oracle/diag子 |
诊断日志。数据库警报日志是/opt/oracle/diag/rdbms/free/FREE/trace/alert_FREE.log |
/opt/oracle/cfgtoollogs/dbca/FREE |
数据库创建日志。该文件包含数据库创建脚本执行的结果。FREE.log |
/etc/sysconfig/oracle-free-23ai.conf |
配置默认参数。 |
/etc/init.d/oracle-free-23ai |
配置和服务脚本。 |
Note
在执行脚本文件时，可以通过下面的方式传入密码。达到静默安装的效果。更多内容请参考 Linux Shell 脚本。
(echo "password"; echo "password";) | /etc/init.d/oracle-free-23ai configure >> /free_logs/FREEsilentinstall.log 2>&1
3.4 配置环境变量
su - oracle
#oracle>
cat >> ~/.bash_profile << EOF
export ORACLE_SID=FREE
export ORAENV_ASK=NO
. /opt/oracle/product/23ai/dbhomeFree/bin/oraenv
EOF
4 数据库启动和停止
4.1 注册数据为守护进程
systemctl daemon-reload
systemctl enable oracle-free-23ai
systemctl status oracle-free-23ai
4.2 数据库的启动与启停
systemctl start oracle-free-23ai
systemctl status oracle-free-23ai
systemctl stop oracle-free-23ai